<?php 
include('connection/connection.php');
?>

<!DOCTYPE HTML>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script type="text/javascript" src="animatedcollapse.js"></script>
<script type="text/javascript">
animatedcollapse.addDiv('q1andq2', 'fade=0,speed=400,group=pets,hide=1')
animatedcollapse.addDiv('q3', 'fade=0,speed=400,group=pets,hide=1')

animatedcollapse.ontoggle=function($, divobj, state){ //fires each time a DIV is expanded/contracted
	//$: Access to jQuery
	//divobj: DOM reference to DIV being expanded/ collapsed. Use "divobj.id" to get its ID
	//state: "block" or "none", depending on state
}
animatedcollapse.init()
</script>

<body>
Select District : 
<label>
<select name="district" id="district">
<option value="">Select district</option>
<?php
$qry="select DISTINCT district_id, district_name from tbl_lookup_location order by district_name";
echo $qry;
$result=mysql_query($qry);
while(list($id, $name)=mysql_fetch_array($result))
{
    echo "<option value=\"$id\">$name</option> \n" ;
}  
?>
</select>
</label>
<p><b>Report List From Questionnaire1 and Questionnaire2</b></p>
<a href="#" rel="toggle[q1andq2]" data-openimage="collapse.jpg" data-closedimage="expand.jpg"><img src="collapse.jpg" border="0" /></a> <a href="javascript:animatedcollapse.show('q1andq2')">Slide Down</a> || <a href="javascript:animatedcollapse.hide('q1andq2')">Slide Up</a>
<div id="q1andq2" style="width: 800px; background: #BDF381;">



<table width="795" border="1">
  <tr>
    <td colspan="2"><div align="center"><strong>List of Report from Questionnaire1 and Questionnaire2 </strong></div></td>
    </tr>
  <tr>
    <td width="69">Table 1 </td>
    <td width="710"><a href="">Block wise number of villages and villages served by  different types of water supply schemes (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 2 </td>
    <td><a href="">Comparison of Number of Schemes between PHED and Field  Survey</a></td>
  </tr>
  <tr>
    <td>Table 3 </td>
    <td><a href="">Block wise Scheme wise population covered (as per  PHED)</a></td>
  </tr>
  <tr>
    <td>Table 4 </td>
    <td><a href="">Scheme wise and Storage Structure wise information on  Reservoir capacity and their sufficiency (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 5 </td>
    <td><a href="">Storage structures for District (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 6 </td>
    <td><a href="">Block wise Scheme Wise Tanker water supply in District  (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 7 </td>
    <td><a href="">Percent population served by different types of  schemes (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 8 </td>
    <td><a href="">Scheme wise Block wise service level (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 9 </td>
    <td><a href="">Block wise Scheme wise water bill raised and revenue  generated (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 10</td>
    <td><a href="">Scheme wise block wise O&amp;M Expenditure and cost of  water supply (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 11</td>
    <td><a href="">Block and Scheme wise cost of water (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 12</td>
    <td><a href="">Comparative analysis of field data for Regional WSS</a></td>
  </tr>
  <tr>
    <td>Table 13</td>
    <td><a href="">Distribution Frequency of Water Supply (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 14</td>
    <td><a href="">Block wise time taken for redressal of complaints (as  per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 15</td>
    <td><a href="">Block wise source details and their status (as per  PHED)</a></td>
  </tr>
  <tr>
    <td>Table 16</td>
    <td><a href="">Block and Scheme wise pumping assets in the district  (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 17</td>
    <td><a href="">Scheme wise status of TW and OW (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 18</td>
    <td><a href="">General information on Handpumps in district (as per  PHED)</a> </td>
  </tr>
  <tr>
    <td>Table 19</td>
    <td><a href="">Block wise schemes wise type of connections and their  number (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 20 </td>
    <td><a href="">Functional status of handpumps (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 21 </td>
    <td><a href="">Operational status of handpumps (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 22 </td>
    <td><a href="">Quality status of handpumps (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 23 </td>
    <td><a href="">Yield status of handpumps (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 24 </td>
    <td><a href="">Block wise percentage of handpumps with seasonal  fluctuation in yield (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 25 </td>
    <td><a href="">Block wise average minimum and maximum water table  fluctuation (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 26 </td>
    <td><a href="">Block wise percentage of non repairable and abandoned  handpumps (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 27 </td>
    <td><a href="">Block wise O&amp;M cost for handpumps (as per PHED)</a></td>
  </tr>
  <tr>
    <td>Table 28 </td>
    <td><a href="">Percentage of schemes where preventive maintenance is  in place</a></td>
  </tr>
  <tr>
    <td>Table 29 </td>
    <td><a href="">Block wise percentage of type of complaints received</a></td>
  </tr>
  <tr>
    <td>Table 30 </td>
    <td><a href="">Percentage of constraints faced by PHED</a></td>
  </tr>
</table>
</div>
<p><b>Report from Questionnaire3</b></p>
<a href="#" rel="toggle[q3]" data-openimage="collapse.jpg" data-closedimage="expand.jpg"><img src="collapse.jpg" border="0" /></a> <a href="javascript:animatedcollapse.show('q3')">Slide Down</a> || <a href="javascript:animatedcollapse.hide('q3')">Slide Up</a>
<div id="q3" style="width: 800px; background: #BDF381;">
<table width="795" border="1">
  <tr>
    <td colspan="2"><div align="center"><strong>List of Report from Questionnaire3 </strong></div></td>
    </tr>
  <tr>
    <td width="69">Table 1 </td>
    <td width="710">&nbsp;</td>
  </tr>
  <tr>
    <td>Table 2 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 3 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 4 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 5 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 6 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 7 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 8 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 9 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 10</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 11</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 12</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 13</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 14</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 15</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 16</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 17</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 18</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 19</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 20 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 21 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 22 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 23 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 24 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 25 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 26 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 27 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 28 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 29 </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Table 30 </td>
    <td>&nbsp;</td>
  </tr>
</table>

</div>


</body>